package sopt.dev.db;

import sopt.dev.db.CityInfoDB.CityDBScheme;

/**
 * Created by Dev on 13. 8. 1.
 */
public class ItemInfoDB {

	/**
	 * @author
	 */
	public static final class ItemDBScheme {

		private ItemDBScheme() {
		}

		public static final String TABLE_NAME = "ITEM_TABLE ";

		public static final String COLUMN_ID = "ITEM_ID ";
		public static final String COLUMN_CITYNAME = CityDBScheme.COLUMN_CITYNAME;
		public static final String COLUMN_NAME = "ITEM_NAME ";
		public static final String COLUMN_DATE = "ITEM_DATE ";
		public static final String COLUMN_TYPE = "ITEM_TYPE ";
		public static final String COLUMN_PRICE = "ITEM_PRICE ";
		public static final String COLUMN_IMGPATH = "ITEM_IMG_PATH ";
		public static final String COLUMN_LATITUDE = "ITEM_LATITUDE";
		public static final String COLUMN_LONGTITUDE = "ITEM_LOMGTITUDE";	
		public static final String COLUMN_ADDRESS = "ITEM_ADDRESS";	
		public static final String COLUMN_COMMENT = "ITEM_COMMENT ";
		public static final String COLUMN_PAYTYPE = "IS_CARD ";

		public static String[] getColumnNames() {
			return new String[]{COLUMN_ID, COLUMN_CITYNAME, COLUMN_NAME, COLUMN_DATE, COLUMN_TYPE, COLUMN_PRICE, 
					COLUMN_IMGPATH, COLUMN_LATITUDE, COLUMN_LONGTITUDE, COLUMN_ADDRESS, COLUMN_COMMENT, COLUMN_PAYTYPE};
		}
		
	public static String getColumnNamesInRow() {
			
			StringBuilder sb = new StringBuilder();
			
			for(String column : getColumnNames()) {
				sb.append(column + " , ");		
			}
			
			return sb.toString();
		}

	}

}
